SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_CheckLinkIsExist]
    (
      @JOL_Link_Title VARCHAR(255)
    )
AS 
    DECLARE @Count INT
    SET @Count = (
                   SELECT   COUNT(JOL_Link_Title)
                   FROM     dbo.JOL_Link
                   WHERE    JOL_Link_Title = @JOL_Link_Title
                 )
    SELECT  @Count

GO
